﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PersonnelDataSet" targetNamespace="http://tempuri.org/PersonnelDataSet.xsd" xmlns:mstns="http://tempuri.org/PersonnelDataSet.xsd" xmlns="http://tempuri.org/PersonnelDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PersonnelConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PersonnelConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ResaPers.My.MySettings.GlobalReference.Default.PersonnelConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersIDTableAdapter" GeneratorDataComponentClassName="PersIDTableAdapter" Name="PersID" UserDataComponentName="PersIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PersonnelConnectionString (MySettings)" DbObjectName="dbo.PersID" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[PersID] WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserPwd = 1 AND [UserPwd] IS NULL) OR ([UserPwd] = @Original_UserPwd)) AND ((@IsNull_UserDroit = 1 AND [UserDroit] IS NULL) OR ([UserDroit] = @Original_UserDroit)) AND ((@IsNull_UserFct = 1 AND [UserFct] IS NULL) OR ([UserFct] = @Original_UserFct)) AND ((@IsNull_UserPresent = 1 AND [UserPresent] IS NULL) OR ([UserPresent] = @Original_UserPresent)) AND ((@IsNull_UserTeam = 1 AND [UserTeam] IS NULL) OR ([UserTeam] = @Original_UserTeam)) AND ((@IsNull_UserNRue = 1 AND [UserNRue] IS NULL) OR ([UserNRue] = @Original_UserNRue)) AND ((@IsNull_UserRue = 1 AND [UserRue] IS NULL) OR ([UserRue] = @Original_UserRue)) AND ((@IsNull_UserCP = 1 AND [UserCP] IS NULL) OR ([UserCP] = @Original_UserCP)) AND ((@IsNull_UserCom = 1 AND [UserCom] IS NULL) OR ([UserCom] = @Original_UserCom)) AND ((@IsNull_UserTel = 1 AND [UserTel] IS NULL) OR ([UserTel] = @Original_UserTel)) AND ((@IsNull_UserGSM = 1 AND [UserGSM] IS NULL) OR ([UserGSM] = @Original_UserGSM)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserDroit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserFct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTeam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNRue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserRue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserCP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserCom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserCom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserGSM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserGSM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[PersID] ([UserID], [UserNom], [UserPrenom], [UserPwd], [UserDroit], [UserFct], [UserPresent], [UserTeam], [UserNRue], [UserRue], [UserCP], [UserCom], [UserTel], [UserGSM]) VALUES (@UserID, @UserNom, @UserPrenom, @UserPwd, @UserDroit, @UserFct, @UserPresent, @UserTeam, @UserNRue, @UserRue, @UserCP, @UserCom, @UserTel, @UserGSM);
SELECT UserID, UserNom, UserPrenom, UserPwd, UserDroit, UserFct, UserPresent, UserTeam, UserNRue, UserRue, UserCP, UserCom, UserTel, UserGSM FROM PersID WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserFct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserCom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserGSM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT UserID, UserNom, UserPrenom, UserPwd, UserDroit, UserFct, UserPresent, UserTeam, UserNRue, UserRue, UserCP, UserCom, UserTel, UserGSM FROM dbo.PersID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[PersID] SET [UserID] = @UserID, [UserNom] = @UserNom, [UserPrenom] = @UserPrenom, [UserPwd] = @UserPwd, [UserDroit] = @UserDroit, [UserFct] = @UserFct, [UserPresent] = @UserPresent, [UserTeam] = @UserTeam, [UserNRue] = @UserNRue, [UserRue] = @UserRue, [UserCP] = @UserCP, [UserCom] = @UserCom, [UserTel] = @UserTel, [UserGSM] = @UserGSM WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserPwd = 1 AND [UserPwd] IS NULL) OR ([UserPwd] = @Original_UserPwd)) AND ((@IsNull_UserDroit = 1 AND [UserDroit] IS NULL) OR ([UserDroit] = @Original_UserDroit)) AND ((@IsNull_UserFct = 1 AND [UserFct] IS NULL) OR ([UserFct] = @Original_UserFct)) AND ((@IsNull_UserPresent = 1 AND [UserPresent] IS NULL) OR ([UserPresent] = @Original_UserPresent)) AND ((@IsNull_UserTeam = 1 AND [UserTeam] IS NULL) OR ([UserTeam] = @Original_UserTeam)) AND ((@IsNull_UserNRue = 1 AND [UserNRue] IS NULL) OR ([UserNRue] = @Original_UserNRue)) AND ((@IsNull_UserRue = 1 AND [UserRue] IS NULL) OR ([UserRue] = @Original_UserRue)) AND ((@IsNull_UserCP = 1 AND [UserCP] IS NULL) OR ([UserCP] = @Original_UserCP)) AND ((@IsNull_UserCom = 1 AND [UserCom] IS NULL) OR ([UserCom] = @Original_UserCom)) AND ((@IsNull_UserTel = 1 AND [UserTel] IS NULL) OR ([UserTel] = @Original_UserTel)) AND ((@IsNull_UserGSM = 1 AND [UserGSM] IS NULL) OR ([UserGSM] = @Original_UserGSM)));
SELECT UserID, UserNom, UserPrenom, UserPwd, UserDroit, UserFct, UserPresent, UserTeam, UserNRue, UserRue, UserCP, UserCom, UserTel, UserGSM FROM PersID WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserFct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserCom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserGSM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserDroit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserFct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPresent" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTeam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTeam" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNRue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNRue" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserRue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserRue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRue" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserCP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserCom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserCom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserCom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserGSM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserGSM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGSM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="UserNom" DataSetColumn="UserNom" />
              <Mapping SourceColumn="UserPrenom" DataSetColumn="UserPrenom" />
              <Mapping SourceColumn="UserPwd" DataSetColumn="UserPwd" />
              <Mapping SourceColumn="UserDroit" DataSetColumn="UserDroit" />
              <Mapping SourceColumn="UserFct" DataSetColumn="UserFct" />
              <Mapping SourceColumn="UserPresent" DataSetColumn="UserPresent" />
              <Mapping SourceColumn="UserTeam" DataSetColumn="UserTeam" />
              <Mapping SourceColumn="UserNRue" DataSetColumn="UserNRue" />
              <Mapping SourceColumn="UserRue" DataSetColumn="UserRue" />
              <Mapping SourceColumn="UserCP" DataSetColumn="UserCP" />
              <Mapping SourceColumn="UserCom" DataSetColumn="UserCom" />
              <Mapping SourceColumn="UserTel" DataSetColumn="UserTel" />
              <Mapping SourceColumn="UserGSM" DataSetColumn="UserGSM" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PersonnelConnectionString (MySettings)" DbObjectName="dbo.PersID" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPresent" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByPresent" GeneratorSourceName="FillByPresent" GetMethodModifier="Public" GetMethodName="GetDataByPresent" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByPresent" UserSourceName="FillByPresent">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserID, UserNom, UserPrenom, UserPwd, UserDroit, UserFct, UserPresent, UserTeam, UserNRue, UserRue, UserCP, UserCom, UserTel, 
                      UserGSM
FROM         PersID
WHERE     (UserPresent = 1)</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PersonnelConnectionString (MySettings)" DbObjectName="dbo.PersID" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByUserID" GeneratorSourceName="FillByUserID" GetMethodModifier="Public" GetMethodName="GetDataByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByUserID" UserSourceName="FillByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserID, UserNom, UserPrenom, UserPwd, UserDroit, UserFct, UserPresent, UserTeam, UserNRue, UserRue, UserCP, UserCom, UserTel, 
                      UserGSM
FROM         PersID
WHERE     (UserID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESAPERS\RESAPERS\PERSONNEL.MDF].dbo.PersID" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PersonnelConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateQueryUserAction" Modifier="Public" Name="UpdateQueryUserAction" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateQueryUserAction">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    PersID
SET              UserPresent = @UserPresent, UserTeam = @UserTeam
WHERE     (UserID = @Original_UserID); 
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="UserPresent" ColumnName="UserPresent" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESAPERS\RESAPERS\PERSONNEL.MDF].dbo.PersID" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserPresent" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserPresent" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="UserTeam" ColumnName="UserTeam" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESAPERS\RESAPERS\PERSONNEL.MDF].dbo.PersID" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@UserTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UserTeam" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Original_UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESAPERS\RESAPERS\PERSONNEL.MDF].dbo.PersID" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PersonnelDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="PersonnelDataSet" msprop:Generator_DataSetName="PersonnelDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PersID" msprop:Generator_UserTableName="PersID" msprop:Generator_RowDeletedName="PersIDRowDeleted" msprop:Generator_TableClassName="PersIDDataTable" msprop:Generator_RowChangedName="PersIDRowChanged" msprop:Generator_RowClassName="PersIDRow" msprop:Generator_RowChangingName="PersIDRowChanging" msprop:Generator_RowEvArgName="PersIDRowChangeEvent" msprop:Generator_RowEvHandlerName="PersIDRowChangeEventHandler" msprop:Generator_TablePropName="PersID" msprop:Generator_TableVarName="tablePersID" msprop:Generator_RowDeletingName="PersIDRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserNom" msprop:Generator_UserColumnName="UserNom" msprop:Generator_ColumnPropNameInRow="UserNom" msprop:Generator_ColumnVarNameInTable="columnUserNom" msprop:Generator_ColumnPropNameInTable="UserNomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPrenom" msprop:Generator_UserColumnName="UserPrenom" msprop:Generator_ColumnPropNameInRow="UserPrenom" msprop:Generator_ColumnVarNameInTable="columnUserPrenom" msprop:Generator_ColumnPropNameInTable="UserPrenomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPwd" msprop:Generator_UserColumnName="UserPwd" msprop:Generator_ColumnPropNameInRow="UserPwd" msprop:Generator_ColumnVarNameInTable="columnUserPwd" msprop:Generator_ColumnPropNameInTable="UserPwdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserDroit" msprop:Generator_UserColumnName="UserDroit" msprop:Generator_ColumnPropNameInRow="UserDroit" msprop:Generator_ColumnVarNameInTable="columnUserDroit" msprop:Generator_ColumnPropNameInTable="UserDroitColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserFct" msprop:Generator_UserColumnName="UserFct" msprop:Generator_ColumnPropNameInRow="UserFct" msprop:Generator_ColumnVarNameInTable="columnUserFct" msprop:Generator_ColumnPropNameInTable="UserFctColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPresent" msprop:Generator_UserColumnName="UserPresent" msprop:Generator_ColumnPropNameInRow="UserPresent" msprop:Generator_ColumnVarNameInTable="columnUserPresent" msprop:Generator_ColumnPropNameInTable="UserPresentColumn" type="xs:int" minOccurs="0" />
              <xs:element name="UserTeam" msprop:Generator_UserColumnName="UserTeam" msprop:Generator_ColumnPropNameInRow="UserTeam" msprop:Generator_ColumnVarNameInTable="columnUserTeam" msprop:Generator_ColumnPropNameInTable="UserTeamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserNRue" msprop:Generator_UserColumnName="UserNRue" msprop:Generator_ColumnPropNameInRow="UserNRue" msprop:Generator_ColumnVarNameInTable="columnUserNRue" msprop:Generator_ColumnPropNameInTable="UserNRueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserRue" msprop:Generator_UserColumnName="UserRue" msprop:Generator_ColumnPropNameInRow="UserRue" msprop:Generator_ColumnVarNameInTable="columnUserRue" msprop:Generator_ColumnPropNameInTable="UserRueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserCP" msprop:Generator_UserColumnName="UserCP" msprop:Generator_ColumnPropNameInRow="UserCP" msprop:Generator_ColumnVarNameInTable="columnUserCP" msprop:Generator_ColumnPropNameInTable="UserCPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserCom" msprop:Generator_UserColumnName="UserCom" msprop:Generator_ColumnPropNameInRow="UserCom" msprop:Generator_ColumnVarNameInTable="columnUserCom" msprop:Generator_ColumnPropNameInTable="UserComColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserTel" msprop:Generator_UserColumnName="UserTel" msprop:Generator_ColumnPropNameInRow="UserTel" msprop:Generator_ColumnVarNameInTable="columnUserTel" msprop:Generator_ColumnPropNameInTable="UserTelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserGSM" msprop:Generator_UserColumnName="UserGSM" msprop:Generator_ColumnPropNameInRow="UserGSM" msprop:Generator_ColumnVarNameInTable="columnUserGSM" msprop:Generator_ColumnPropNameInTable="UserGSMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PersID" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
  </xs:element>
</xs:schema>